Hệ thống quản lý trường đại học bằng PHP
1 <?php require('../includes/config.php'); ?>
2 <!DOCTYPE HTML>
3 <html>
4 <head>
5 <title>Institut national des sciences appliquées et de technologie</title>
6 <meta charset="utf-8" />
7 <meta http-equiv="X-UA-Compatible" content="IE=edge">
8 <meta name="viewport" content="width=device-width, initial-scale=1">
9 <link href="../assets/css/bootstrap.css" rel="stylesheet">
10 <link rel="stylesheet" href="../assets/css/main.css" />
11 <link href="../assets/css/simple-sidebar.css" rel="stylesheet">
12 </head>
13 <body title="member">
14 <?php require('../includes/header.php'); ?>
15 <div id="wrapper">
16 <!-- Sidebar -->
17 <div id="sidebar-wrapper">
18 <ul class="sidebar-nav">
19 <li class="sidebar-brand">
20 <a href="../index_member.php">
21 Espace Membre
22 </a>
23 </li>
24 <li>
25 <a href="filiereSelec.php?type=C">Cours</a>
26 </li>
27 <li>
28 <a href="filiereSelec.php?type=AD">Anciens Devoirs</a>
29 </li>
30 <li>
31 <a href="filiereSelec.php?type=E">Exercices</a>
32 </li>
33 <li>
34 <a href="filiereSelec.php?type=R">Résultats</a>
35 </li>
36 </ul>
37 </div>
38 <!-- /#sidebar-wrapper -->
39 <!-- Page Content -->
40 <div id="page-content-wrapper">
41 <div class="container-fluid">
42 <div class="row">
43 <div class="col-lg-12">
44 <h1>Results</h1>
45 </div>
46 <div class="row">
47 <div class="col-lg-12">
48 <div class="panel panel-default">
49 <div class="panel-heading">
50 <?php
51 $matiere = $_GET['matiereID'];
52 $type = $_GET['type'];
53 $filiere = $_GET['lvlID'];
54 ?>
55 </div>
56 <!-- /.panel-heading -->
57 <div class="panel-body">
58 <div class="dataTable_wrapper">
59
60 <table class="table table-striped table-bordered table-hover" id="dataTables-example">
61 <thead>
62 <tr>
63 <th>Cin</th>
64 <th>Nom</th>
65 <th>Prenom</th>
66 <?php
67 $req = $db->prepare('SELECT nature , COUNT(*) FROM Note
68 WHERE Note.matiereID = :matiereID
69 AND Note.lvlID = :lvlID
70 GROUP BY Note.nature
71 ORDER BY Note.nature
72 ');
73 $req->execute(array(':matiereID'=> $matiere , ':lvlID' => $filiere));
74 while($row = $req->fetch()){
75 ?>
76 <th>Note <?= $row['nature'] ?></th>
77 <?php
78 }
79 ?>
80 </tr>
81 </thead>
82 <tbody>
83 <?php
84 $stmt = $db->prepare('SELECT * FROM Note INNER JOIN Etudiant
85 ON Note.carteEtudiant = Etudiant.carteEtudiant
86 WHERE Note.matiereID = :matiereID
87 AND Note.lvlID = :lvlID
88 GROUP BY Note.carteEtudiant
89 ');
90 $stmt->execute(array(':matiereID'=> $matiere , ':lvlID' => $filiere));
91 while($row = $stmt->fetch()){
92 ?>
93 <tr class="odd gradeX">
94 <td><?php if (($row['cin'] %10000000)==$row['cin'])
95 echo '0';
96 echo $row['cin'];
97 ?></td>
98 <td><?= $row['nom'] ?></td>
99 <td><?= $row['prenom'] ?></td>
100 <?php $stud = $db->prepare('SELECT * FROM Note INNER JOIN Etudiant
101 ON Note.carteEtudiant = Etudiant.carteEtudiant
102 WHERE Note.matiereID = :matiereID
103 AND Note.lvlID = :lvlID
104 AND Note.carteEtudiant = :carteEtudiant
105 ORDER BY Note.nature
106 ');
107 $stud->execute(array(':matiereID'=> $matiere , ':lvlID' => $filiere, ':carteEtudiant' => $row['carteEtudiant']));
108 while($note = $stud->fetch()){
109 ?>
110 <td><?= $note['valeur'] ?></td>
111 <?php
112 }
113 ?>
114 </tr>
115 <?php
116 }
117 ?>
118 </tbody>
119 </table>
120 </div>
121 </div>
122 <!-- /.panel-body -->
123 </div>
124 <!-- /.panel -->
125 </div>
126 <!-- /.col-lg-12 -->
127 </div>
128 </div>
129 </div>
130 </div>
131 <!-- /#page-content-wrapper -->
132 </div>
133 <!-- /#wrapper -->
134 <!-- jQuery -->
135 <script src="../assets/js/jquery.js"></script>
136 <!-- Bootstrap Core JavaScript -->
137 <script src="../assets/js/bootstrap.min.js"></script>
138 <!-- Menu Toggle Script -->
139 <!-- Scripts -->
140 <script src="../assets/js/jquery.min.js"></script>
141 <script src="../assets/js/skel.min.js"></script>
142 <script src="../assets/js/util.js"></script>
143 <!--[if lte IE 8]><script src="assets/js/ie/respond.min.js"></script><![endif]-->
144 <script src="../assets/js/main.js"></script>
145 <!-- Include all compiled plugins (below), or include individual files as needed -->
146 <script src = "//maxcdn.bootstrapcdn.com/bootstrap/3.3.1/js/bootstrap.min.js"></script>
147 </body>
148 </html>